/**
 * Created by Cloud on 2016/4/11.
 */
var dao = require("./execsql.js");
exports.mylist=function(req,res){
    var myid=req.body.myid;
    console.log(myid);

    var sql="SELECT article_title,image_src,parise_number,post_reason,shop_name,shop_address FROM hc_infomation a1 LEFT JOIN hc_infoimgs_reference a2 ON a1.article_id=a2.article_id JOIN hc_images a3 ON a2.image_id=a3.image_id WHERE article_classification='"+myid+"' GROUP BY article_title";
    dao.poolGetConnection(sql,res)
};
exports.mydianzan=function (req,res){
    var mytupian = req.body.tupian;
    var parise_number = req.body.parise_number;
    console.log(mytupian);
    console.log(parise_number);
    var sql="UPDATE hc_infomation SET parise_number='"+parise_number+"' WHERE shop_name='"+mytupian+"'";
    dao.poolGetConnection(sql,res)
};